/*
 Navicat Premium Data Transfer

 Source Server         : root
 Source Server Type    : MySQL
 Source Server Version : 80022
 Source Host           : localhost:3306
 Source Schema         : im_java

 Target Server Type    : MySQL
 Target Server Version : 80022
 File Encoding         : 65001

 Date: 21/04/2021 18:58:09
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for community
-- ----------------------------
DROP TABLE IF EXISTS `community`;
CREATE TABLE `community` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(24) NOT NULL COMMENT '群名称',
  `owner_email` varchar(64) NOT NULL COMMENT '群主Email',
  `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '群logo',
  `memo` varchar(255) DEFAULT NULL COMMENT '群简介',
  `create_at` bigint NOT NULL DEFAULT '0' COMMENT '时间戳',
  `delete_timestamp` bigint NOT NULL DEFAULT '0' COMMENT '0未删除；删除时间戳',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `owner_email` (`owner_email`),
  CONSTRAINT `community_ibfk_1` FOREIGN KEY (`owner_email`) REFERENCES `user` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=1004 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of community
-- ----------------------------
BEGIN;
INSERT INTO `community` VALUES (1000, '软件架构课程交流群', 'hjm@163.com', 'https://im-java.oss-cn-shenzhen.aliyuncs.com/images/1618985589853_5726bbf7.jpg', NULL, 1618847453422, 0);
COMMIT;

-- ----------------------------
-- Table structure for contact
-- ----------------------------
DROP TABLE IF EXISTS `contact`;
CREATE TABLE `contact` (
  `id` int NOT NULL AUTO_INCREMENT,
  `owner_email` varchar(64) NOT NULL COMMENT '添加端的Email',
  `dst_obj` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '被添加端的Email | Id',
  `cate` int NOT NULL COMMENT '区分 好友 | 群',
  `memo` varchar(255) DEFAULT NULL COMMENT '简介',
  `create_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `delete_timestamp` bigint NOT NULL DEFAULT '0' COMMENT '0未删除；删除时间戳',
  PRIMARY KEY (`id`),
  KEY `owner_email` (`owner_email`,`dst_obj`,`cate`)
) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of contact
-- ----------------------------
BEGIN;
INSERT INTO `contact` VALUES (118, 'test2@163.com', 'hjm@163.com', 1, NULL, '2021-04-21 16:34:08', 0);
INSERT INTO `contact` VALUES (119, 'hjm@163.com', 'test2@163.com', 1, NULL, '2021-04-21 16:34:08', 0);
INSERT INTO `contact` VALUES (120, 'hjm@163.com', '1000', 2, NULL, '2021-04-21 16:40:53', 0);
INSERT INTO `contact` VALUES (121, '1000', 'hjm@163.com', 2, NULL, '2021-04-21 16:40:53', 0);
INSERT INTO `contact` VALUES (122, 'hjm@163.com', 'test@163.com', 1, NULL, '2021-04-21 16:46:41', 0);
INSERT INTO `contact` VALUES (123, 'test@163.com', 'hjm@163.com', 1, NULL, '2021-04-21 16:46:41', 0);
INSERT INTO `contact` VALUES (124, 'test@163.com', '1000', 2, NULL, '2021-04-21 17:06:03', 0);
INSERT INTO `contact` VALUES (125, '1000', 'test@163.com', 2, NULL, '2021-04-21 17:06:03', 0);
INSERT INTO `contact` VALUES (126, 'hjm@163.com', 'qyt@163.com', 1, NULL, '2021-04-21 18:12:37', 0);
INSERT INTO `contact` VALUES (127, 'qyt@163.com', 'hjm@163.com', 1, NULL, '2021-04-21 18:12:37', 0);
INSERT INTO `contact` VALUES (128, 'hjm@163.com', 'ljl@163.com', 1, NULL, '2021-04-21 18:12:40', 0);
INSERT INTO `contact` VALUES (129, 'ljl@163.com', 'hjm@163.com', 1, NULL, '2021-04-21 18:12:40', 0);
INSERT INTO `contact` VALUES (130, 'hjm@163.com', 'hxd@163.com', 1, NULL, '2021-04-21 18:12:40', 0);
INSERT INTO `contact` VALUES (131, 'hxd@163.com', 'hjm@163.com', 1, NULL, '2021-04-21 18:12:40', 0);
COMMIT;

-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_email` varchar(64) NOT NULL COMMENT '发送方邮箱',
  `cmd` int NOT NULL COMMENT '业务（广播，心跳检测，私聊，群聊）',
  `dst_obj` varchar(64) NOT NULL COMMENT '接收方（用户，群）',
  `msg_type` int NOT NULL COMMENT '消息展示方式',
  `content` varchar(255) DEFAULT NULL COMMENT '发送的内容',
  `create_at` bigint unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `delete_timestamp` bigint NOT NULL DEFAULT '0' COMMENT '0未删除；删除时间戳',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1698 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of message
-- ----------------------------
BEGIN;
INSERT INTO `message` VALUES (1443, 'hjm@163.com', 10, 'hxd@163.com', 1, '1', 1618820966177, 0);
INSERT INTO `message` VALUES (1444, 'hjm@163.com', 10, 'hxd@163.com', 1, '2', 1618820967473, 0);
INSERT INTO `message` VALUES (1445, 'hjm@163.com', 10, 'hxd@163.com', 1, '3', 1618820968929, 0);
INSERT INTO `message` VALUES (1446, 'hjm@163.com', 10, 'hxd@163.com', 1, '4', 1618820970389, 0);
INSERT INTO `message` VALUES (1447, 'hjm@163.com', 10, 'hxd@163.com', 1, '5', 1618820972561, 0);
INSERT INTO `message` VALUES (1448, 'hxd@163.com', 10, 'hjm@163.com', 1, '@(便便)', 1618821082483, 0);
INSERT INTO `message` VALUES (1449, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(怒)', 1618821122413, 0);
INSERT INTO `message` VALUES (1450, 'hjm@163.com', 11, '1000', 1, '@(惊讶)', 1618827105519, 0);
INSERT INTO `message` VALUES (1451, 'hjm@163.com', 11, '1000', 1, '@(汗)', 1618836355248, 0);
INSERT INTO `message` VALUES (1452, 'hxd@163.com', 10, 'hjm@163.com', 1, '@(原谅她)', 1618836370562, 0);
INSERT INTO `message` VALUES (1453, 'hxd@163.com', 10, 'hjm@163.com', 1, '@(爱心)', 1618837447741, 0);
INSERT INTO `message` VALUES (1454, 'hxd@163.com', 10, 'hjm@163.com', 1, '@(彩虹)', 1618837480447, 0);
INSERT INTO `message` VALUES (1455, 'hjm@163.com', 11, '1000', 1, '@(茶杯)', 1618837500210, 0);
INSERT INTO `message` VALUES (1456, 'hjm@163.com', 11, '1000', 1, '@(蛋糕)', 1618837517342, 0);
INSERT INTO `message` VALUES (1457, 'hjm@163.com', 11, '1000', 1, '@(惊讶)', 1618837613233, 0);
INSERT INTO `message` VALUES (1458, 'hjm@163.com', 11, '1000', 1, '@(惊讶)', 1618837645311, 0);
INSERT INTO `message` VALUES (1459, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(黑线)', 1618837934172, 0);
INSERT INTO `message` VALUES (1460, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(红领巾)', 1618837945496, 0);
INSERT INTO `message` VALUES (1461, 'hxd@163.com', 10, 'hjm@163.com', 1, '@(汗)', 1618837950793, 0);
INSERT INTO `message` VALUES (1462, 'hjm@163.com', 11, '1000', 1, '@(红领巾)', 1618838023495, 0);
INSERT INTO `message` VALUES (1463, 'hxd@163.com', 11, '1000', 1, '@(大拇指)', 1618838033282, 0);
INSERT INTO `message` VALUES (1464, 'hjm@163.com', 11, '1000', 1, '@(开心)', 1618838038112, 0);
INSERT INTO `message` VALUES (1465, 'hxd@163.com', 11, '1000', 1, '@(惊哭)', 1618838059531, 0);
INSERT INTO `message` VALUES (1466, 'hjm@163.com', 11, '1000', 1, '@(呵呵)', 1618838073875, 0);
INSERT INTO `message` VALUES (1467, 'hjm@163.com', 10, 'hxd@163.com', 1, 'this is a test', 1618838091606, 0);
INSERT INTO `message` VALUES (1468, 'hxd@163.com', 11, '1000', 1, '@(红领巾)', 1618838148411, 0);
INSERT INTO `message` VALUES (1469, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(惊恐)', 1618838167938, 0);
INSERT INTO `message` VALUES (1470, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(大拇指)', 1618838207586, 0);
INSERT INTO `message` VALUES (1471, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(吃瓜)', 1618838210940, 0);
INSERT INTO `message` VALUES (1472, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(爱心)', 1618838213188, 0);
INSERT INTO `message` VALUES (1473, 'hxd@163.com', 10, 'hjm@163.com', 1, '@(大拇指)', 1618838252349, 0);
INSERT INTO `message` VALUES (1474, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(黑线)', 1618838468857, 0);
INSERT INTO `message` VALUES (1475, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(黑线)', 1618838487631, 0);
INSERT INTO `message` VALUES (1476, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(嘚瑟)', 1618838506784, 0);
INSERT INTO `message` VALUES (1477, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(呼)', 1618838535740, 0);
INSERT INTO `message` VALUES (1478, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(鄙视)', 1618838551086, 0);
INSERT INTO `message` VALUES (1479, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(便便)', 1618838670992, 0);
INSERT INTO `message` VALUES (1480, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(大拇指)', 1618838680637, 0);
INSERT INTO `message` VALUES (1481, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(呵呵)', 1618838759109, 0);
INSERT INTO `message` VALUES (1482, 'hjm@163.com', 10, 'hxd@163.com', 1, 'this is a test。你好，世界！', 1618838804152, 0);
INSERT INTO `message` VALUES (1483, 'hjm@163.com', 10, 'hxd@163.com', 1, 'this is a test。@(爱心)你好，世界！@(呵呵)', 1618838814578, 0);
INSERT INTO `message` VALUES (1484, 'hjm@163.com', 10, 'hxd@163.com', 1, 'this is a test。你好，世界！this is a test。你好，世界！this is a test。你好，世界！this is a test。你好，世界！this is a test。你好，世界！this is a test。你好，世界！@(汗)', 1618838825928, 0);
INSERT INTO `message` VALUES (1485, 'hjm@163.com', 10, 'hxd@163.com', 1, 'this is a test\nhello world!', 1618838850424, 0);
INSERT INTO `message` VALUES (1486, 'hxd@163.com', 10, 'hjm@163.com', 1, '@(黑线)', 1618838975110, 0);
INSERT INTO `message` VALUES (1487, 'hxd@163.com', 11, '1000', 1, '@(大拇指)', 1618839366401, 0);
INSERT INTO `message` VALUES (1488, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(黑线)', 1618840134819, 0);
INSERT INTO `message` VALUES (1489, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(汗)', 1618840237177, 0);
INSERT INTO `message` VALUES (1490, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(汗)', 1618840240508, 0);
INSERT INTO `message` VALUES (1491, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(吃翔)', 1618840243787, 0);
INSERT INTO `message` VALUES (1492, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(惊恐)', 1618840272036, 0);
INSERT INTO `message` VALUES (1493, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(汗)', 1618840280544, 0);
INSERT INTO `message` VALUES (1494, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(吃翔)', 1618840285218, 0);
INSERT INTO `message` VALUES (1495, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(蛋糕)', 1618840287499, 0);
INSERT INTO `message` VALUES (1496, 'hjm@163.com', 10, 'hxd@163.com', 1, 'this is test\n', 1618840294729, 0);
INSERT INTO `message` VALUES (1497, 'hjm@163.com', 10, 'hxd@163.com', 1, '1', 1618840296568, 0);
INSERT INTO `message` VALUES (1498, 'hjm@163.com', 10, 'hxd@163.com', 1, '2', 1618840297443, 0);
INSERT INTO `message` VALUES (1499, 'hjm@163.com', 10, 'hxd@163.com', 1, '3', 1618840298430, 0);
INSERT INTO `message` VALUES (1500, 'hxd@163.com', 10, 'hjm@163.com', 1, '@(大拇指)', 1618840454906, 0);
INSERT INTO `message` VALUES (1501, 'hjm@163.com', 11, '1000', 1, '@(呵呵)', 1618840618021, 0);
INSERT INTO `message` VALUES (1502, 'hjm@163.com', 11, '1000', 1, '@(吃翔)', 1618840620254, 0);
INSERT INTO `message` VALUES (1503, 'hxd@163.com', 11, '1000', 1, '@(汗)', 1618840624414, 0);
INSERT INTO `message` VALUES (1504, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(呵呵)', 1618840728683, 0);
INSERT INTO `message` VALUES (1505, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(汗)', 1618840758161, 0);
INSERT INTO `message` VALUES (1506, 'hjm@163.com', 11, '1000', 1, '@(汗)', 1618840763439, 0);
INSERT INTO `message` VALUES (1507, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(汗)', 1618840769951, 0);
INSERT INTO `message` VALUES (1508, 'hjm@163.com', 11, '1000', 1, '@(汗)', 1618840776500, 0);
INSERT INTO `message` VALUES (1509, 'hjm@163.com', 11, '1000', 1, '@(大拇指)', 1618840866374, 0);
INSERT INTO `message` VALUES (1510, 'hjm@163.com', 11, '1000', 1, '@(蛋糕)', 1618840886056, 0);
INSERT INTO `message` VALUES (1511, 'hjm@163.com', 11, '1000', 1, '@(吃翔)', 1618840912685, 0);
INSERT INTO `message` VALUES (1512, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(惊哭)', 1618840987389, 0);
INSERT INTO `message` VALUES (1513, 'hjm@163.com', 11, '1000', 1, '@(鄙视)', 1618841450086, 0);
INSERT INTO `message` VALUES (1514, 'hjm@163.com', 11, '1000', 2, 'https://im-java.oss-cn-shenzhen.aliyuncs.com/images/1618841543105_721a3024.jpg', 1618841543249, 0);
INSERT INTO `message` VALUES (1515, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(便便)', 1618842038949, 0);
INSERT INTO `message` VALUES (1516, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(红领巾)', 1618844991379, 0);
INSERT INTO `message` VALUES (1517, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(汗)', 1618845002812, 0);
INSERT INTO `message` VALUES (1518, 'hjm@163.com', 10, 'test@163.com', 1, '@(呵呵)', 1618914407785, 0);
INSERT INTO `message` VALUES (1519, 'test@163.com', 10, 'hjm@163.com', 1, '@(彩虹)', 1618914435185, 0);
INSERT INTO `message` VALUES (1520, 'test@163.com', 10, 'hjm@163.com', 1, '@(蛋糕)', 1618914456414, 0);
INSERT INTO `message` VALUES (1521, 'test@163.com', 10, 'hjm@163.com', 1, '@(呵呵)', 1618923720024, 0);
INSERT INTO `message` VALUES (1522, 'hjm@163.com', 10, 'test@163.com', 1, '@(大拇指)', 1618927929108, 0);
INSERT INTO `message` VALUES (1523, 'test@163.com', 11, '1000', 1, '@(爱心)', 1618928733160, 0);
INSERT INTO `message` VALUES (1524, 'test@163.com', 10, 'hjm@163.com', 1, '@(呵呵)', 1618929529528, 0);
INSERT INTO `message` VALUES (1525, 'test@163.com', 10, 'hjm@163.com', 1, '@(呵呵)@(惊哭)', 1618929540625, 0);
INSERT INTO `message` VALUES (1526, 'test@163.com', 10, 'hjm@163.com', 1, '@(呵呵)@(惊哭)', 1618929545807, 0);
INSERT INTO `message` VALUES (1527, 'test@163.com', 10, 'hjm@163.com', 1, '@(呵呵)@(惊哭)', 1618929553270, 0);
INSERT INTO `message` VALUES (1528, 'test@163.com', 10, 'hjm@163.com', 1, '@(嘚瑟)', 1618929597172, 0);
INSERT INTO `message` VALUES (1529, 'test@163.com', 10, 'hjm@163.com', 1, '@(惊讶)', 1618929638129, 0);
INSERT INTO `message` VALUES (1530, 'test@163.com', 10, 'hjm@163.com', 1, '@(黑线)', 1618929961901, 0);
INSERT INTO `message` VALUES (1531, 'test@163.com', 10, 'hjm@163.com', 1, '@(黑线)', 1618930041420, 0);
INSERT INTO `message` VALUES (1532, 'test@163.com', 10, 'hjm@163.com', 1, '@(惊哭)', 1618930140739, 0);
INSERT INTO `message` VALUES (1533, 'test@163.com', 10, 'hjm@163.com', 1, '@(呵呵)', 1618930159679, 0);
INSERT INTO `message` VALUES (1534, 'test@163.com', 10, 'hjm@163.com', 1, '123', 1618930165414, 0);
INSERT INTO `message` VALUES (1535, 'test@163.com', 11, '1000', 1, '@(嘚瑟)', 1618930313859, 0);
INSERT INTO `message` VALUES (1536, 'hjm@163.com', 10, 'test@163.com', 1, '@(黑线)', 1618930813752, 0);
INSERT INTO `message` VALUES (1537, 'hjm@163.com', 10, 'hxd@163.com', 1, '@(嘚瑟)', 1618930822643, 0);
INSERT INTO `message` VALUES (1538, 'test@163.com', 11, '1000', 1, '@(大拇指)', 1618930957610, 0);
INSERT INTO `message` VALUES (1539, 'test@163.com', 11, '1000', 1, '@(吃翔)', 1618931498070, 0);
INSERT INTO `message` VALUES (1540, 'hjm@163.com', 11, '1000', 1, '@(爱心)', 1618931508080, 0);
INSERT INTO `message` VALUES (1541, 'hxd@163.com', 11, '1000', 1, '@(吃瓜)', 1618931530675, 0);
INSERT INTO `message` VALUES (1542, 'test@163.com', 10, 'hjm@163.com', 1, '@(爱心)', 1618847740340, 0);
INSERT INTO `message` VALUES (1543, 'test@163.com', 10, 'hjm@163.com', 1, '@(惊恐)', 1618971536443, 0);
INSERT INTO `message` VALUES (1544, 'hjm@163.com', 10, 'test@163.com', 1, '@(黑线)', 1618971548936, 0);
INSERT INTO `message` VALUES (1545, 'hjm@163.com', 10, 'test@163.com', 1, '1', 1618971553190, 0);
INSERT INTO `message` VALUES (1546, 'hjm@163.com', 10, 'test@163.com', 1, '2', 1618971554492, 0);
INSERT INTO `message` VALUES (1547, 'hjm@163.com', 10, 'test@163.com', 1, '3', 1618971555668, 0);
INSERT INTO `message` VALUES (1548, 'hjm@163.com', 10, 'test@163.com', 1, '@(惊哭)', 1618971659542, 0);
INSERT INTO `message` VALUES (1549, 'hjm@163.com', 10, 'test@163.com', 1, '@(惊恐)', 1618971724163, 0);
INSERT INTO `message` VALUES (1550, 'hjm@163.com', 10, 'test@163.com', 1, '1', 1618971725940, 0);
INSERT INTO `message` VALUES (1551, 'hjm@163.com', 10, 'test@163.com', 1, '1', 1618971952088, 0);
INSERT INTO `message` VALUES (1552, 'hjm@163.com', 10, 'test@163.com', 1, '2', 1618971953875, 0);
INSERT INTO `message` VALUES (1553, 'hjm@163.com', 10, 'test@163.com', 1, '1', 1618971966879, 0);
INSERT INTO `message` VALUES (1554, 'hjm@163.com', 10, 'test@163.com', 1, '2', 1618971967964, 0);
INSERT INTO `message` VALUES (1555, 'hjm@163.com', 10, 'test@163.com', 1, '3', 1618971969698, 0);
INSERT INTO `message` VALUES (1556, 'hjm@163.com', 10, 'test@163.com', 1, '123', 1618972089352, 0);
INSERT INTO `message` VALUES (1557, 'hjm@163.com', 10, 'test@163.com', 1, '1', 1618972093314, 0);
INSERT INTO `message` VALUES (1558, 'hjm@163.com', 10, 'test@163.com', 1, '2', 1618972094241, 0);
INSERT INTO `message` VALUES (1559, 'hjm@163.com', 10, 'test@163.com', 1, '3', 1618972096517, 0);
INSERT INTO `message` VALUES (1560, 'test@163.com', 11, '1000', 1, '@(爱心)\n', 1618972260931, 0);
INSERT INTO `message` VALUES (1561, 'hjm@163.com', 11, '1000', 1, '@(汗)', 1618972271693, 0);
INSERT INTO `message` VALUES (1562, 'hjm@163.com', 11, '1000', 1, '123', 1618972293537, 0);
INSERT INTO `message` VALUES (1563, 'hjm@163.com', 11, '1000', 1, '1', 1618972296465, 0);
INSERT INTO `message` VALUES (1564, 'hjm@163.com', 11, '1000', 1, '2', 1618972297374, 0);
INSERT INTO `message` VALUES (1565, 'hjm@163.com', 11, '1000', 1, '3', 1618972298206, 0);
INSERT INTO `message` VALUES (1566, 'hjm@163.com', 11, '1000', 1, '123', 1618972351585, 0);
INSERT INTO `message` VALUES (1567, 'hjm@163.com', 11, '1000', 1, '123', 1618972435713, 0);
INSERT INTO `message` VALUES (1568, 'hjm@163.com', 10, 'test@163.com', 1, '1', 1618972659411, 0);
INSERT INTO `message` VALUES (1569, 'hjm@163.com', 10, 'test@163.com', 1, '2', 1618972660433, 0);
INSERT INTO `message` VALUES (1570, 'hjm@163.com', 10, 'test@163.com', 1, '3', 1618972661267, 0);
INSERT INTO `message` VALUES (1571, 'hjm@163.com', 11, '1000', 1, '1', 1618972747736, 0);
INSERT INTO `message` VALUES (1572, 'hjm@163.com', 11, '1000', 1, '2', 1618972748724, 0);
INSERT INTO `message` VALUES (1573, 'hjm@163.com', 11, '1000', 1, '3', 1618972749644, 0);
INSERT INTO `message` VALUES (1574, 'hjm@163.com', 10, 'test@163.com', 1, '1', 1618972742282, 0);
INSERT INTO `message` VALUES (1575, 'hjm@163.com', 10, 'test@163.com', 1, '2', 1618972743250, 0);
INSERT INTO `message` VALUES (1576, 'hjm@163.com', 10, 'test@163.com', 1, '3', 1618972744557, 0);
INSERT INTO `message` VALUES (1577, 'hjm@163.com', 10, 'test@163.com', 1, '1', 1618972825651, 0);
INSERT INTO `message` VALUES (1578, 'hjm@163.com', 10, 'test@163.com', 1, '2', 1618972826459, 0);
INSERT INTO `message` VALUES (1579, 'hjm@163.com', 10, 'test@163.com', 1, '3', 1618972827237, 0);
INSERT INTO `message` VALUES (1580, 'hjm@163.com', 10, 'test@163.com', 1, '1', 1618972901940, 0);
INSERT INTO `message` VALUES (1581, 'hjm@163.com', 10, 'test@163.com', 1, '2', 1618972902713, 0);
INSERT INTO `message` VALUES (1582, 'hjm@163.com', 10, 'test@163.com', 1, '3', 1618972903532, 0);
INSERT INTO `message` VALUES (1583, 'hjm@163.com', 10, 'test@163.com', 1, '1', 1618973206668, 0);
INSERT INTO `message` VALUES (1584, 'hjm@163.com', 11, '1000', 1, '1', 1618973396174, 0);
INSERT INTO `message` VALUES (1585, 'hjm@163.com', 11, '1000', 1, '2', 1618973396852, 0);
INSERT INTO `message` VALUES (1586, 'hjm@163.com', 11, '1000', 1, '3', 1618973397546, 0);
INSERT INTO `message` VALUES (1587, 'hjm@163.com', 10, 'test@163.com', 1, '1', 1618973391816, 0);
INSERT INTO `message` VALUES (1588, 'hjm@163.com', 10, 'test@163.com', 1, '2', 1618973392770, 0);
INSERT INTO `message` VALUES (1589, 'hjm@163.com', 10, 'test@163.com', 1, '3', 1618973393478, 0);
INSERT INTO `message` VALUES (1590, 'hjm@163.com', 11, '1000', 1, '1', 1618973532297, 0);
INSERT INTO `message` VALUES (1591, 'hjm@163.com', 11, '1000', 1, '2\n', 1618973533068, 0);
INSERT INTO `message` VALUES (1592, 'hjm@163.com', 11, '1000', 1, '3', 1618973534369, 0);
INSERT INTO `message` VALUES (1593, 'hjm@163.com', 10, 'test@163.com', 1, '1', 1618973527115, 0);
INSERT INTO `message` VALUES (1594, 'hjm@163.com', 10, 'test@163.com', 1, '2', 1618973528946, 0);
INSERT INTO `message` VALUES (1595, 'hjm@163.com', 10, 'test@163.com', 1, '3', 1618973529770, 0);
INSERT INTO `message` VALUES (1596, 'hjm@163.com', 11, '1000', 1, '1', 1618973689301, 0);
INSERT INTO `message` VALUES (1597, 'hjm@163.com', 11, '1000', 1, '2', 1618973689980, 0);
INSERT INTO `message` VALUES (1598, 'hjm@163.com', 11, '1000', 1, '3', 1618973690751, 0);
INSERT INTO `message` VALUES (1599, 'hjm@163.com', 10, 'test@163.com', 1, '1', 1618973685212, 0);
INSERT INTO `message` VALUES (1600, 'hjm@163.com', 10, 'test@163.com', 1, '2', 1618973685959, 0);
INSERT INTO `message` VALUES (1601, 'hjm@163.com', 10, 'test@163.com', 1, '3', 1618973686674, 0);
INSERT INTO `message` VALUES (1602, 'hjm@163.com', 11, '1000', 1, '1', 1618974163146, 0);
INSERT INTO `message` VALUES (1603, 'hjm@163.com', 11, '1000', 1, '2', 1618974163892, 0);
INSERT INTO `message` VALUES (1604, 'hjm@163.com', 11, '1000', 1, '3', 1618974166233, 0);
INSERT INTO `message` VALUES (1605, 'hjm@163.com', 11, '1000', 1, '1', 1618974174735, 0);
INSERT INTO `message` VALUES (1606, 'hjm@163.com', 11, '1000', 1, '2', 1618974175479, 0);
INSERT INTO `message` VALUES (1607, 'hjm@163.com', 11, '1000', 1, '3', 1618974176200, 0);
INSERT INTO `message` VALUES (1608, 'hjm@163.com', 10, 'test@163.com', 1, '1', 1618974252238, 0);
INSERT INTO `message` VALUES (1609, 'hjm@163.com', 10, 'test@163.com', 1, '2', 1618974253071, 0);
INSERT INTO `message` VALUES (1610, 'hjm@163.com', 10, 'test@163.com', 1, '3', 1618974253814, 0);
INSERT INTO `message` VALUES (1611, 'hjm@163.com', 10, 'test@163.com', 1, '1', 1618974441422, 0);
INSERT INTO `message` VALUES (1612, 'hjm@163.com', 10, 'test@163.com', 1, '2', 1618974442081, 0);
INSERT INTO `message` VALUES (1613, 'hjm@163.com', 10, 'test@163.com', 1, '3', 1618974442867, 0);
INSERT INTO `message` VALUES (1614, 'hjm@163.com', 10, 'test@163.com', 1, '1', 1618974508523, 0);
INSERT INTO `message` VALUES (1615, 'hjm@163.com', 10, 'test@163.com', 1, '2', 1618974509217, 0);
INSERT INTO `message` VALUES (1616, 'hjm@163.com', 10, 'test@163.com', 1, '3', 1618974509968, 0);
INSERT INTO `message` VALUES (1617, 'hjm@163.com', 10, 'test@163.com', 1, '1', 1618974594195, 0);
INSERT INTO `message` VALUES (1618, 'hjm@163.com', 10, 'test@163.com', 1, '2', 1618974594948, 0);
INSERT INTO `message` VALUES (1619, 'hjm@163.com', 10, 'test@163.com', 1, '3', 1618974595711, 0);
INSERT INTO `message` VALUES (1620, 'hjm@163.com', 10, 'test@163.com', 1, '1', 1618974676055, 0);
INSERT INTO `message` VALUES (1621, 'hjm@163.com', 10, 'test@163.com', 1, '2', 1618974676755, 0);
INSERT INTO `message` VALUES (1622, 'hjm@163.com', 10, 'test@163.com', 1, '3', 1618974677571, 0);
INSERT INTO `message` VALUES (1623, 'hjm@163.com', 10, 'test@163.com', 1, '@(呵呵)', 1618979459593, 0);
INSERT INTO `message` VALUES (1624, 'hjm@163.com', 10, 'test@163.com', 1, '1', 1618979499719, 0);
INSERT INTO `message` VALUES (1625, 'hjm@163.com', 10, 'test@163.com', 1, 'this is a test', 1618979774494, 0);
INSERT INTO `message` VALUES (1626, 'hjm@163.com', 10, 'test@163.com', 1, '@(惊恐)', 1618979781623, 0);
INSERT INTO `message` VALUES (1627, 'jrp@163.com', 10, 'ljl@163.com', 1, '？？？？\n', 1618986605110, 0);
INSERT INTO `message` VALUES (1628, 'jrp@163.com', 10, 'qyt@163.com', 1, '？？？？', 1618986609039, 0);
INSERT INTO `message` VALUES (1629, 'jrp@163.com', 10, 'hjc@163.com', 1, '？？？？', 1618986612924, 0);
INSERT INTO `message` VALUES (1630, 'jrp@163.com', 10, 'hjm@163.com', 1, '？？？？？', 1618986616839, 0);
INSERT INTO `message` VALUES (1631, 'qyt@163.com', 10, 'jrp@163.com', 2, 'https://im-java.oss-cn-shenzhen.aliyuncs.com/images/1618986619762_cb9c78b6.jpg', 1618986620225, 0);
INSERT INTO `message` VALUES (1632, 'ljl@163.com', 10, 'jrp@163.com', 1, '干嘛\n', 1618986643491, 0);
INSERT INTO `message` VALUES (1633, 'hjm@163.com', 11, '1000', 1, '+1', 1618986646747, 0);
INSERT INTO `message` VALUES (1634, 'jrp@163.com', 10, 'qyt@163.com', 1, '@(嘚瑟)', 1618986649886, 0);
INSERT INTO `message` VALUES (1635, 'ljl@163.com', 11, '1000', 1, '1\n', 1618986652621, 0);
INSERT INTO `message` VALUES (1636, 'hjc@163.com', 11, '1000', 1, '+1\n', 1618986664713, 0);
INSERT INTO `message` VALUES (1637, 'jrp@163.com', 11, '1000', 1, '@(doge)', 1618986668791, 0);
INSERT INTO `message` VALUES (1638, 'qyt@163.com', 11, '1000', 1, '+1', 1618986685883, 0);
INSERT INTO `message` VALUES (1639, 'hjc@163.com', 11, '1000', 1, '@(汗)\n', 1618986694396, 0);
INSERT INTO `message` VALUES (1640, 'qyt@163.com', 10, 'jrp@163.com', 1, '\n@(吃翔)', 1618986702578, 0);
INSERT INTO `message` VALUES (1641, 'ljl@163.com', 11, '1000', 2, 'https://im-java.oss-cn-shenzhen.aliyuncs.com/images/1618986704729_0ce08d77.jpg', 1618986705510, 0);
INSERT INTO `message` VALUES (1642, 'qyt@163.com', 11, '1000', 1, '@(吃翔)', 1618986713361, 0);
INSERT INTO `message` VALUES (1643, 'hjc@163.com', 11, '1000', 1, '@(惊恐)\n', 1618986721357, 0);
INSERT INTO `message` VALUES (1644, 'ljl@163.com', 11, '1000', 1, '@(吃瓜)', 1618986737723, 0);
INSERT INTO `message` VALUES (1645, 'hjc@163.com', 11, '1000', 1, '哈哈哈哈哈哈哈', 1618986743449, 0);
INSERT INTO `message` VALUES (1646, 'qyt@163.com', 11, '1000', 1, '@(真棒)', 1618986794684, 0);
INSERT INTO `message` VALUES (1647, 'ljl@163.com', 11, '1000', 3, 'https://im-java.oss-cn-shenzhen.aliyuncs.com/videos/1618986822291_7225de17.mp4', 1618986823921, 0);
INSERT INTO `message` VALUES (1648, 'hjc@163.com', 10, 'ljl@163.com', 1, '你是？', 1618986826306, 0);
INSERT INTO `message` VALUES (1649, 'ljl@163.com', 11, '1000', 1, '@(吃翔)\n', 1618986881202, 0);
INSERT INTO `message` VALUES (1650, 'hjc@163.com', 11, '1000', 1, '@(红领巾)', 1618986902032, 0);
INSERT INTO `message` VALUES (1651, 'ljl@163.com', 11, '1000', 1, '@(惊讶)', 1618986955578, 0);
INSERT INTO `message` VALUES (1652, 'ljl@163.com', 11, '1000', 1, '@(花心)', 1618986968481, 0);
INSERT INTO `message` VALUES (1653, 'hjc@163.com', 11, '1000', 1, '@(太阳)', 1618986972434, 0);
INSERT INTO `message` VALUES (1654, 'ljl@163.com', 11, '1000', 1, '@(酷)', 1618987032739, 0);
INSERT INTO `message` VALUES (1655, 'hjc@163.com', 11, '1000', 1, '哈哈哈哈', 1618987085512, 0);
INSERT INTO `message` VALUES (1656, 'jrp@163.com', 11, '1000', 1, '0.0\n', 1618987121954, 0);
INSERT INTO `message` VALUES (1657, 'ljl@163.com', 11, '1000', 1, '@(大拇指)', 1618987175470, 0);
INSERT INTO `message` VALUES (1658, 'ljl@163.com', 11, '1000', 1, '@(惊恐)', 1618987212689, 0);
INSERT INTO `message` VALUES (1659, 'qyt@163.com', 11, '1000', 1, '@(彩虹)', 1618987266757, 0);
INSERT INTO `message` VALUES (1660, 'ljl@163.com', 11, '1000', 1, '@(OK)', 1618987281623, 0);
INSERT INTO `message` VALUES (1661, 'hjc@163.com', 11, '1000', 1, '@(吃瓜)', 1618987357771, 0);
INSERT INTO `message` VALUES (1662, 'ljl@163.com', 11, '1000', 1, '@(惊恐)', 1618987367241, 0);
INSERT INTO `message` VALUES (1663, 'hjc@163.com', 11, '1000', 1, '@(惊哭)', 1618987380267, 0);
INSERT INTO `message` VALUES (1664, 'jrp@163.com', 11, '1000', 1, '@(吃翔)', 1618987396836, 0);
INSERT INTO `message` VALUES (1665, 'ljl@163.com', 11, '1000', 1, '@(what)', 1618987409271, 0);
INSERT INTO `message` VALUES (1666, 'jrp@163.com', 11, '1000', 2, 'https://im-java.oss-cn-shenzhen.aliyuncs.com/images/1618987450263_cb7f6cb0.jpg', 1618987455556, 0);
INSERT INTO `message` VALUES (1667, 'ljl@163.com', 11, '1000', 1, '@(吃翔)@(嘚瑟)', 1618987485964, 0);
INSERT INTO `message` VALUES (1668, 'ljl@163.com', 11, '1000', 1, '@(惊恐)\n', 1618987496301, 0);
INSERT INTO `message` VALUES (1669, 'jrp@163.com', 11, '1000', 1, '@(真棒)', 1618987496701, 0);
INSERT INTO `message` VALUES (1670, 'ljl@163.com', 10, 'qyt@163.com', 1, '@(惊恐)', 1618987589352, 0);
INSERT INTO `message` VALUES (1671, 'ljl@163.com', 10, 'qyt@163.com', 1, '@(惊哭)', 1618987593383, 0);
INSERT INTO `message` VALUES (1672, 'ljl@163.com', 10, 'hjc@163.com', 1, '@(滑稽)', 1618988613791, 0);
INSERT INTO `message` VALUES (1673, 'hjc@163.com', 10, 'ljl@163.com', 1, '?', 1618988620557, 0);
INSERT INTO `message` VALUES (1674, 'test2@163.com', 10, 'hjm@163.com', 1, '@(呵呵)', 1618994297941, 0);
INSERT INTO `message` VALUES (1675, 'test2@163.com', 10, 'hjm@163.com', 1, 'this is a test', 1618994306254, 0);
INSERT INTO `message` VALUES (1676, 'hjm@163.com', 11, '1000', 1, '@(惊恐)', 1618994465192, 0);
INSERT INTO `message` VALUES (1677, 'hjm@163.com', 11, '1000', 1, 'hello world!', 1618994471825, 0);
INSERT INTO `message` VALUES (1678, 'hjm@163.com', 10, 'test@163.com', 1, 'this is a test', 1618995934783, 0);
INSERT INTO `message` VALUES (1679, 'hjm@163.com', 10, 'test@163.com', 1, '@(惊恐)', 1618995939043, 0);
INSERT INTO `message` VALUES (1680, 'test@163.com', 11, '1000', 1, '@(爱心)', 1618995985753, 0);
INSERT INTO `message` VALUES (1681, 'test@163.com', 11, '1000', 1, '@(吃翔)', 1618995998570, 0);
INSERT INTO `message` VALUES (1682, 'hjm@163.com', 11, '1000', 1, '@(惊恐)', 1618996004793, 0);
INSERT INTO `message` VALUES (1683, 'hjm@163.com', 11, '1000', 1, '@(汗)', 1618996431277, 0);
INSERT INTO `message` VALUES (1684, 'hjm@163.com', 11, '1000', 1, '@(吃翔)', 1618996434107, 0);
INSERT INTO `message` VALUES (1685, 'hjm@163.com', 11, '1000', 1, '@(吃翔)@(爱心)this is a test', 1618996445557, 0);
INSERT INTO `message` VALUES (1686, 'hjm@163.com', 10, 'test@163.com', 1, '@(汗)@(滑稽)@(吃瓜)', 1618996404212, 0);
INSERT INTO `message` VALUES (1687, 'hjm@163.com', 10, 'test@163.com', 1, '123123', 1618996411440, 0);
INSERT INTO `message` VALUES (1688, 'hjm@163.com', 10, 'test@163.com', 1, '@(惊恐)@(灯泡)@(彩虹)', 1618996420903, 0);
INSERT INTO `message` VALUES (1689, 'hjm@163.com', 10, 'test@163.com', 1, '@(惊恐)@(灯泡)', 1618996425302, 0);
INSERT INTO `message` VALUES (1690, 'test@163.com', 10, 'hjm@163.com', 1, '你好，何同学@(爱心)', 1618999731764, 0);
INSERT INTO `message` VALUES (1691, 'test@163.com', 10, 'hjm@163.com', 1, '你好，小民同学@(爱心)', 1618999767331, 0);
INSERT INTO `message` VALUES (1692, 'hjm@163.com', 10, 'test@163.com', 1, '你好，何同学@(大拇指)', 1618999784932, 0);
INSERT INTO `message` VALUES (1693, 'test@163.com', 10, 'hjm@163.com', 2, 'https://im-java.oss-cn-shenzhen.aliyuncs.com/images/1618999793990_d29bf5d0.jpg', 1618999794188, 0);
INSERT INTO `message` VALUES (1694, 'hjm@163.com', 10, 'test@163.com', 1, '@(嘚瑟)', 1618999808137, 0);
INSERT INTO `message` VALUES (1695, 'hjm@163.com', 10, 'test@163.com', 1, '@(嘚瑟)', 1619000072255, 0);
INSERT INTO `message` VALUES (1696, 'hjm@163.com', 10, 'test@163.com', 1, '@(哈哈)', 1619000075470, 0);
INSERT INTO `message` VALUES (1697, 'hjm@163.com', 10, 'test@163.com', 1, '这是离线消息', 1619000077359, 0);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `email` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户电子邮箱地址',
  `password` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户登录密码',
  `salt` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '盐',
  `uname` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户名称',
  `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
  `create_at` bigint NOT NULL DEFAULT '0' COMMENT '创建时间戳',
  `delete_timestamp` bigint NOT NULL DEFAULT '0' COMMENT '0未删除；删除时间戳',
  PRIMARY KEY (`id`),
  KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (26, 'test@163.com', '9EA5B666F769EC46A611178CA832C359', 'fuoLrS', '何同学', 'https://im-java.oss-cn-shenzhen.aliyuncs.com/images/1618999685414_2213b87d.gif', 1618847453422, 0);
INSERT INTO `user` VALUES (29, 'hjm@163.com', '2A8ADA4F04C56E7ED6FBD55640263F28', 'NDpcuA', '原来是小民同学呀', 'https://im-java.oss-cn-shenzhen.aliyuncs.com/images/1618999480827_dd8406dd.jpg', 1618914288981, 0);
INSERT INTO `user` VALUES (30, 'hxd@163.com', '4220888910091F3B35AD77AE94287501', 'NwSVeN', '何小呆', NULL, 1618930760098, 0);
INSERT INTO `user` VALUES (39, 'ljl@163.com', '60602B9534F54110BFA7F3AAFE8FC888', 'WPuxiL', '刘俊玲', 'https://im-java.oss-cn-shenzhen.aliyuncs.com/images/1618987350295_39c7d53e.jpg', 1618985725334, 0);
INSERT INTO `user` VALUES (40, 'qyt@163.com', '2F6228F721E4446592AFCBCB8F98F563', 'DqzeDh', '哔哔哔的小心肝', 'https://im-java.oss-cn-shenzhen.aliyuncs.com/images/1618986391803_fb66c07e.png', 1618986368706, 0);
INSERT INTO `user` VALUES (41, 'hjc@163.com', '373F2BDFE8726FF6CBA1E80F0CC5D62B', 'Y3o6e6', '胡金翠', 'https://im-java.oss-cn-shenzhen.aliyuncs.com/images/1618986456234_5632d736.jpg', 1618986375819, 0);
INSERT INTO `user` VALUES (42, 'jrp@163.com', 'AEF842D8A5385F23C6B7013509DF4682', '1t7Ycw', '小蒋', 'https://im-java.oss-cn-shenzhen.aliyuncs.com/images/1618987142063_3e274b90.jpeg', 1618986384260, 0);
INSERT INTO `user` VALUES (43, 'test2@163.com', '9B58F31EC065BCDF749950FC244CE421', 'wljFwc', 'test456', 'https://im-java.oss-cn-shenzhen.aliyuncs.com/images/1618985589853_5726bbf7.jpg', 1618993248102, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
